[ROOT] dt FactResellerSale PIVOT DimSalesTerritory.Name+'_'+DimCurrency.Name BY OrderDate.Year() SUM SalesAmount TITLE Reseller sales pr Sales territory country and year (note inclusion of currency for 'safety' reasons)
12 items
| DimSalesTerritory.Name+'_'+DimCurrency.NameId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| United States, Central_US Dollar | 7906008.08 | 1417108.04 | 2721466.04 | 3068129.48 | 699304.52 |
| United States, Southeast_US Dollar | 7867415.75 | 2119806.51 | 2622561.35 | 2452000.96 | 673046.93 |
| France_US Dollar | 4116990.29 | 0.00 | 1000116.90 | 2425819.20 | 691054.19 |
| United States, Southwest_US Dollar | 18466458.96 | 2903623.29 | 6609277.42 | 7218244.24 | 1735314.01 |
| United States, Northwest_US Dollar | 12435076.03 | 2549204.79 | 3294493.64 | 5122438.56 | 1468939.04 |
| United Kingdom_United Kingdom Pound | 4279008.89 | 0.00 | 1115664.59 | 2428703.00 | 734641.30 |
| France_EURO | 490547.63 | 0.00 | 95778.96 | 306579.77 | 88188.90 |
| Australia_Australian Dollar | 1594334.85 | 0.00 | 0.00 | 1187909.98 | 406424.87 |
| Germany_EURO | 1983987.75 | 0.00 | 0.00 | 1490584.32 | 493403.43 |
| Canada_Canadian Dollar | 14377925.71 | 2289115.20 | 5055862.93 | 5666832.16 | 1366115.42 |
| United States, Northeast_US Dollar | 6932842.17 | 855764.59 | 2826368.58 | 2669582.26 | 581126.74 |
| _SUM | 80450596.11 | 12134622.42 | 25341590.41 | 34036823.93 | 8937559.35 |
Generated 2024-05-16 09:45:43.922 UTC